Only data from 2016-07-01 onwards are included!
Raw dataset consists of 5,888,029 monthly stats of 346,581 properties.
First, 550 records of 33 properties located in remote areas (Christmas Island, Cocos (Keeling) Islands, Norfolk Island, Lord Howe Island) were excluded.
Second, 2,529,946 records of 266,638 inactive properties (sic!) were excluded.
10,341 records of 8,053 properties with missing info on max_guests had their max_guests racalculated to be 1*number of bedrooms.
For 622 records of 407 properties with missing info on max_guests that also had bedrooms info missing, max_guests was racalculated to be 1.
Final dataset of 3,357,533 monthly records of 324,872 properties was aggregated to SA3 levels.
Locations of Airbnb properties (points) were linked to ABS data of SA3 areas (polygons) from 2016. Spatial join in ArcGIS was used with CLOSEST option to capture locations that did not overlap with polygons (see example here https://www.airbnb.com/rooms/19103554 - due to privacy reasons, locations are not exact).
Illawarra Catchment Reserve area, has no Airbnbs. Excluded from analyses!.
Time series filled to inlcude 0s in areaXmonths aggregations with no observations.
Calculating proportion of GNO from one region & one month treated as 1.